package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.bean.LoginBean;

public class qiantui extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("UTF-8");
		HttpSession session = request.getSession();
		LoginBean bean = new LoginBean();
		bean = (LoginBean) session.getAttribute("Loginbean");
		String username = bean.getUsername();
		Date now = new Date();
		SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
		SimpleDateFormat timeFormat = new SimpleDateFormat("HH:mm:ss");
		String date = dateFormat.format(now);
		String time = timeFormat.format(now);
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		String url = "jdbc:mysql://localhost:3306/graduatedesign";
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "update  kaoqin set qiantui=? where username='"+username+"' and date='"+date+"'";
		try {
			conn = DriverManager.getConnection(url, "root", "root");
			stmt = conn.createStatement();
			PreparedStatement preStmt = conn.prepareStatement(sql);
			preStmt.setString(1, time);
			int suc = preStmt.executeUpdate();
			if (suc != 0) {
				response.sendRedirect("admin/daka.jsp");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);
	}
}
